NETFLIX STREAMING CASE STUDY

Step 2: Entity Identification (Netflix)

Netflix System Banner

The video streaming platform operational workflow is represented by 10 core tables:

🔹 ACCOUNTS — Billing Base

Attribute	Data Type	Description
account_id	INT, PK	Unique customer billing account ID
email	VARCHAR	Primary login credentials
subscription_plan	VARCHAR	Pricing tier (`BASIC` = 1 screen, `STANDARD` = 2 screens, `PREMIUM` = 4 screens)
status	VARCHAR	Account status (`ACTIVE`, `SUSPENDED`, `CANCELLED`)

🔹 PROFILES — Sub-Users

Attribute	Data Type	Description
profile_id	INT, PK	Unique user profile ID
account_id	INT, FK	Parent billing account reference
name	VARCHAR	Display name of the profile (e.g. "Dad", "Kids Room")
avatar_url	VARCHAR	Profile icon URL
maturity_limit	VARCHAR	Maximum rating limit allowed (`G`, `PG`, `PG-13`, `R`, `TV-MA`)
is_kids	BOOLEAN	Flag restricting search and home feed to kids-only content

🔹 VIDEOS — General Content Supertype

Attribute	Data Type	Description
video_id	INT, PK	Unique video catalog item identifier
title	VARCHAR	Title name
description	TEXT	Catalog summary
duration_seconds	INT	Content length in seconds
maturity_rating	VARCHAR	Rating class (`G`, `PG`, `PG-13`, `R`, `TV-MA`)
video_type	VARCHAR	Classifier indicator (`MOVIE`, `EPISODE`)

🔹 MOVIES — Subtype Table

Attribute	Data Type	Description
movie_id	INT, PK, FK -> videos.video_id	References general video record
director	VARCHAR	Movie director
theatrical_release_date	DATE	Release history

🔹 SHOWS — TV Series Master

Attribute	Data Type	Description
show_id	INT, PK	Unique television series identifier
title	VARCHAR	TV Series name
maturity_rating	VARCHAR	Series rating class

🔹 SEASONS — TV Series Levels

🔹 EPISODES — Subtype Table

Attribute	Data Type	Description
episode_id	INT, PK, FK -> videos.video_id	References general video record
season_id	INT, FK	Parent TV season level
episode_number	INT	Episode index sequence

🔹 WATCH_HISTORY — Playback Tracker

Attribute	Data Type	Description
history_id	INT, PK	Unique playback log record
profile_id	INT, FK	Active user profile
video_id	INT, FK	Catalog video watched
last_watched_position_seconds	INT	Current playback cursor in seconds
last_updated_time	TIMESTAMP	Last heartbeat check-in time
is_completed	BOOLEAN	Flagged True if user watched 90% or more

🔹 CDN_NODES — Edge Cache Servers

Attribute	Data Type	Description
node_id	INT, PK	Unique caching hardware server ID
name	VARCHAR	Node appliance hostname
region	VARCHAR	Geographic area (e.g., `US-EAST`, `EU-WEST`)
ip_address	VARCHAR	Server IP

🔹 VIDEO_CACHES — Video Location Map

Attribute	Data Type	Description
cache_id	INT, PK	Caching registry identifier
video_id	INT, FK	Video cached
cdn_node_id	INT, FK	Edge server storing the video
quality	VARCHAR	Streaming format cache (`SD`, `HD`, `UHD_4K`)

lock

This content is reserved for Premium Members.

Submit Technical Query